-- ----------------------------
-- Table structure for user_address
-- ----------------------------
DROP TABLE IF EXISTS `user_address`;
CREATE TABLE `user_address` (
  `id` varchar(64) NOT NULL COMMENT '地址主键id',
  `user_id` varchar(64) NOT NULL COMMENT '关联用户id',
  `receiver` varchar(32) NOT NULL COMMENT '收件人姓名',
  `mobile` varchar(32) NOT NULL COMMENT '收件人手机号',
  `province` varchar(32) NOT NULL COMMENT '省份',
  `city` varchar(32) NOT NULL COMMENT '城市',
  `district` varchar(32) NOT NULL COMMENT '区县',
  `detail` varchar(128) NOT NULL COMMENT '详细地址',
  `extand` varchar(128) DEFAULT NULL COMMENT '扩展字段',
  `is_default` int(11) DEFAULT NULL COMMENT '是否默认地址',
  `created_time` datetime NOT NULL COMMENT '创建时间',
  `updated_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='用户地址表 ';

-- ----------------------------
-- Records of user_address
-- ----------------------------
BEGIN;
INSERT INTO `user_address` VALUES ('2011158020WAW3XP', '210227D3PA9FDN9P', 'llb', '18682459804', '北京', '北京', '东城区', '128号', NULL, 1, '2021-02-28 19:13:22', '2021-02-28 19:13:22');
INSERT INTO `user_address` VALUES ('2309114D18Z7XSK4', '230907BCFM80SAY8', '牙牙乐', '18682449803', '广东', '深圳', '龙岗区', '光雅园', NULL, 1, '2023-09-11 14:15:27', '2023-09-11 14:15:27');
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` varchar(64) NOT NULL COMMENT '主键id 用户id',
  `username` varchar(32) NOT NULL COMMENT '用户名 用户名',
  `password` varchar(64) NOT NULL COMMENT '密码 密码',
  `nickname` varchar(32) DEFAULT NULL COMMENT '昵称 昵称',
  `realname` varchar(128) DEFAULT NULL COMMENT '真实姓名',
  `face` varchar(1024) NOT NULL COMMENT '头像',
  `mobile` varchar(32) DEFAULT NULL COMMENT '手机号 手机号',
  `email` varchar(32) DEFAULT NULL COMMENT '邮箱地址 邮箱地址',
  `sex` int(11) DEFAULT NULL COMMENT '性别 性别 1:男  0:女  2:保密',
  `birthday` date DEFAULT NULL COMMENT '生日 生日',
  `created_time` datetime NOT NULL COMMENT '创建时间 创建时间',
  `updated_time` datetime NOT NULL COMMENT '更新时间 更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='用户表 ';

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES ('210227D3PA9FDN9P', 'liulb001', 'gVjoYS6vwaTxL+NvBmK4Ag==', 'liulb001', NULL, 'https://img4.sycdn.imooc.com/5f3e46e500016b8102000200-140-140.jpg', NULL, NULL, 2, '1900-01-01', '2021-02-27 18:24:06', '2021-02-27 18:24:06');
INSERT INTO `users` VALUES ('230907BCFM80SAY8', 'yayale', '8ODT2fWChT4ppZBw2PHpEw==', 'yayale', '牙牙乐', 'https:/ailbin-1302692288.cos.ap-guangzhou.myqcloud.com/foodie/faces/230907BCFM80SAY8/yayale.jpg.jpg', '18175849547', 'yayale@qq.com', 0, '1997-06-25', '2023-09-07 16:02:22', '2023-09-10 10:08:16');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;